package com.aaa.custom.dao.orderDao;

import com.aaa.entity.cart_order.kwc.OrderProduct;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * fileName:OrderPuodectDao
 * description:
 * author:xxx
 * createTime:2020/1/13 9:16
 * version:1.0.0
 */
public interface  OrderProductDao {

    /**
     * 根据订单编号查询最新商品信息
     * @param order_sn
     * @return
     */
    @Select("select pp.id,pp.name,pp.price,pp.shop_id,pp.description,pp.original_price," +
            "pp.album_id,pp.pic FROM oms_order_item ooi,pms_product pp where ooi.product_id=pp.id" +
            " and ooi.order_sn = #{order_sn}")
    List<OrderProduct> getProductByOrdersn(String order_sn);
}
